<table width="98%" cellpadding="3" cellspacing="0" border="0">

            <?php 
			
		$where = ' WHERE 1=1 ';	
		if( $_GET['vaga'] != '' ){
			$where .= " AND (LCASE(no_vaga) like LCASE('%".$_GET['vaga']."%') OR LCASE(ds_vaga) like LCASE('%".$_GET['vaga']."%'))";
		}
		if( $_GET['sg_uf'] != 'all' && $_GET['sg_uf'] != '' ){
			$where .= " AND sg_uf like '%".$_GET['sg_uf']."%' ";
		}		
		if( $_GET['nivel'] != 'all' && $_GET['nivel'] != '' ){
			$where .= " AND co_hierarquia = ".$_GET['nivel']." ";
		}		

		$objRegistro  =  $objConn->Execute("SELECT *,DATE_FORMAT(dt_cadastro,'%d/%m/%Y') as dt_cadastro2
											FROM
											  tbl_vaga
											 $where
											ORDER BY dt_cadastro DESC");
		
		if( $objError->semErros() && $objRegistro->_numOfRows > 0)
		{
		    
			while( !$objRegistro->EOF ) { 
					
			
?>
            <tr>
              <td width="100%" align="left" valign="middle" bgcolor="#F8F8F8" ><div style="font-size:14px;color:#333333"> <strong><?php echo $objRegistro->fields['no_vaga']; ?></strong></div>
                <strong><br />
                Data de Cadastro</strong>: <?php echo $objRegistro->fields['dt_cadastro2']; ?><br />
              </td>
  </tr>
            <tr>
              <td width="100%" align="right" valign="middle" bgcolor="#ffffff"><a href="detalhes_vagas.php?<?php echo md5('actionRegistro').'='.md5( $objRegistro->fields['co_vaga'] ); ?>"><img src="images/icones/mais.png" width="119" height="34" border="0" /></a>                <hr style="height:1px" /></td>
  </tr>
            <?php $objRegistro->MoveNext();
			}
		} else{
	?>
            <tr>
              <td width="100%" align="left" valign="middle" bgcolor="#F8F8F8">Nenhuma vaga encontrada.</td>
  </tr>
            <?php }?>
            </table>